



           

using System;
using System.Collections.Generic;
using System.Web;
using System.Data.Common;
using Shohdi.DataHandler;
using System.Data;




namespace DatabaseComponent
{
    
    public partial class HistoryVisitsDB
    {

        /// <summary>
        /// this function will get the history visits count
        /// </summary>
        /// <param name="con">the connection of the lms database</param>
        /// <returns>a long number of the count</returns>
        public long getMyCount(ClassDataHandler con)
        {
            DataTable dtNew = con.SelectInDataTable(" select count(*) from dbo.HistoryVisits " ,CommandType.Text);

            if (dtNew.Rows.Count > 0)
                return long.Parse(dtNew.Rows[0][0].ToString());
            else
                return 0;
        }

        /// <summary>
        /// this function will get the history visits count
        /// </summary>
        /// <returns>a long number of the count</returns>
        public long getMyCount()
        {
            ClassDataHandler con = new ClassDataHandler(_Connection, _Provider);
            con.OpenConnection();

            long ret = getMyCount(con);

            con.CloseConnection();

            return ret;
        }
        
        
            //Write any additional methods or properties here 
          //Don't modify any genrated classes
    }

}

                        